This function is very similar to the already provided "HEX()" function in MySQL.
What it provides is the following:

1. This project provides similarly named functions across MySQL and SQL Server
   platforms to reduce differences between the MySQL and SQL Server statements.

2. It formats the output to start with "0x".
